﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Petaframe.DataAccess.IntegrationTests.helpers
{
    [TableName("Categories")]
    class Category
    {
        [TablePrimaryKey(AutoIncrement = true)]
        public decimal CategoryID { get; set; }

        public string CategoryName { get; set; }

        public string Description { get; set; }
      
    }

    [TableName("Categories")]
    class CategorySqlServer
    {
        [TablePrimaryKey(AutoIncrement = true)]
        public int CategoryID { get; set; }

        public string CategoryName { get; set; }

        public string Description { get; set; }

    }

  
    [TableName("Categories")]
    class CategoryWithoutPropertyAttributes
    {
       
        public decimal CategoryID { get; set; }

        public string CategoryName { get; set; }

        public string Description { get; set; }             
    }

    class CategoryWithoutTableNameAttribute
    {

        public decimal CategoryID { get; set; }

        public string CategoryName { get; set; }

        public string Description { get; set; }
    }

    [TableName("Categories")]
    class CategoryWithComplexTypes
    {
        //[TablePrimaryKey(AutoIncrement = true)]
        public decimal CategoryID { get; set; }

        public string CategoryName { get; set; }

        public string Description { get; set; }

        public Guid ColumnStamp { get; set; }
        public byte[] Info { get; set; }

    }

    [TableName("Categories")]
    class CategoryWithCompositeKey
    {
        [TablePrimaryKey(AutoIncrement = false)]
        public decimal CategoryID { get; set; }

        [TablePrimaryKey(AutoIncrement = false)]
        public string CategoryName { get; set; }

        public string Description { get; set; }
    }

}
